I have just converted an Excel 2010 powerpivot workbook to Excel 2013.  When I try to expand a field in the pivot table I get "This Pivot Table report is invalid. Try refreshing the data . . "  So I refreshed the data but it did not fix the problem.  I didn't have this problem when converting other 2010 workbooks.  Please advise.

Hi,

As far as I know, the error might be caused by some factors. Please try the following methods:

1) Check the source data range   If the PivotTable report is based on data from a Microsoft Excel worksheet, make sure that the source data has not been deleted. If the source data is from a named range and you used the name to specify the source data when you created the PivotTable report, make sure that the name has not been deleted from the source workbook. Please check the names in a workbook.

2) Check the external data source   For reports that are based on external data, make sure the database is available and you can connect to it.

3) Make sure your system has enough memory   If a report is not valid when you open a workbook, quit any programs you don't need so that more memory is available, and then try to open the workbook again.

4) Wait for the refresh to complete before copying a report   When you refresh a PivotTable report, make sure the refresh is complete and the status bar displays "Ready" before you copy or paste the report into another workbook.

5) Check the file format   If you are opening a PivotTable report that was created in XLS format, and the report has calculated fields or has a page field that's set to retrieve data for each item individually, make sure you save the report in XLSX format (click Save As on the File menu, and click Microsoft Excel Workbook in the Save as type box). Then, if you need to, you can save the workbook in an earlier Excel format.

6) Deleted all slicers connecting to this pivot table. Change the data soure to the table name just like "[Table1]" without path. Insert new slicers.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

It was the slicer.  I just removed and replaced it and its running fine now.  Thanks.